# 放置一些通用参数的查询
from utils.DbConnUtil import executeSql


# 查询支付类型
def queryPayTypes():
    sql = 'SELECT DISTINCT f_pay_type FROM t_order_income_config WHERE f_status = 1 AND f_is_refund = 0'
    result = executeSql(sql)

    payTypes = ''
    for i in range(result.size):
        value = result["f_pay_type"][i]

        if not payTypes:
            payTypes += value
        else:
            payTypes += ',' + value

    return payTypes
